-: Within this lecture
I want to work on a clustered column chart
where we compare three different companies
within different years.
Okay, let's grab the data.
We have Graphic Card sales revenue
between different years in billion USD
between three companies. Graph X, Turbo, and Herz.
I will take the entire table.
I'll go to insert, chart, column chart,
and insert a clustered column to compare those competitors.
All right, let me enlarge this a little.
I like to do it like that.
Okay, Graph X, Turbo, and Herz.
This is task number one.
Insert a clustered column chart.
Task number two will be to change Graph X and Herz,
because Graph X has a little bit lower values.
And with this presentation,
I wanted to actually compare Turbo and Herz.
This is only additional data.
We have many ways of switching around data.
For example, I can select this entire part of the table.
I can move my mouse to the site. I can press shift,
And when I move it forward you can see
it has this little bold line.
It will be simply put as the last one.
This is one way of doing so.
Let me press Ctrl + Z.
I wanna show you another way.
Another way is to select this entire column
press Ctrl, or command + X to cut it.
Go now to the last column, and simply insert cut cells.
It would also cut the first one, and insert it at the end.
All right, we have now Turbo and Herz as the first ones.
This is...
This is me. I forgot to minimize myself.
And we completed task number one and two.
Number three, put legend on the right side.
It's very simple to put a legend to the side.
You can click on the legend itself.
For example, you can do it on the plus sign.
You have the legend.
You can open the legend options, and put it on the right.
Now, it takes up very little space,
so I would maybe move the chart a little,
and simply make this a little bigger.
You can also make this bigger by going to Home,
and increasing the font
if you wanted to give this a little bit more space
I think this is okay.
We've put the legend on the right side.
Number four, add data labels for Turbo and Herz.
Turbo is this one. Herz is the second one.
So I will just select the first data series.
Again, go to the plus sign, and ensure data labels.
I'll do the same for the second series.
I can hover my mouse.
Okay, series Herz.
Data labels as well.
I think they are a bit small, so I can click
on the data labels and I can enlarge it
just by pressing this little icon
to make it stand out a bit.
I do this very often.
Ctrl + B, because we completed this task.
Number five, reduce series overlap and gap width.
This is something specific to column charts,
and I wanna show you.
I'll click on this chart
just right click on any series, format data series,
and in the format data series options
you can actually change how much of a gap
is between the series, between the companies,
and how much of a gap we have between the categories.
For example, like, this would make it a bit cluster,
but we can increase the overlap to connect them together
and increase the gap width.
So we have big gaps between the years.
Sometimes this is what you need to do
if you have very little space for your chart
but the regular gap width is pretty okay,
and it looks very nice.
This is a bonus option I wanted to show you
specific to this type of chart.
I'll press Ctrl + B.
Now, remove horizontal line, and y-axis.
Since we already have data labels here
I think we do not have to duplicate the data labels
on the left side.
You can just select this axis and press delete.
Do you want the horizontal lines?
Maybe I delete the horizontal lines.
What if I want vertical lines? No problem.
Press the plus sign, grid lines, primary vertical lines.
They would now beautifully divide different years
from each other.
I hope you've enjoyed this little lecture.
Please try to replicate the steps,
and we will see each other in the next lecture.
See you there.